Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerGroupID (PK) | A unique identification number assigned to a customer group | ID_GP_ID | Identity | integer | |
CustomerGroupTypeCode (FK) | A retailer assigned, mnemonic code denoting a kind of CustomerGroup. Eg: Taxation Exemption, Promotions. | CD_TYP_CT_GP | Code4 | char(4) | CustomerGroupType(CO_TYP_GP_CT) |
Name | The business name applied to a customer group. | NM_GP | Name | varchar(40) | |
Description | The text description applied to a customer group. | DE_GP_CT | DescriptionShort | varchar(255) | |